﻿CREATE TABLE [dbo].[TransformationBreakdown]
(
	[TransformationBreakdownId] SMALLINT NOT NULL PRIMARY KEY, 
	[TransformationId] SMALLINT NULL ,
    [Breakdown] NVARCHAR(100) NOT NULL, 
    [AllowsFreeText] BIT NOT NULL DEFAULT 1, 
    [Values] NVARCHAR(1000) NULL, 
    [DefaultValue] NVARCHAR(50) NULL, 
    CONSTRAINT [FK_TransformationBreakdown_Transformation] FOREIGN KEY ([TransformationId]) REFERENCES [dbo].[Transformation]([TransformationId])
)
